Creating Data-Driven Web Sites by Bob Terrell

Author:Bob Terrell
Language: eng
Format: epub
Publisher: Momentum Press
Published: 2019-04-14T16:00:00+00:00

An example of an ENUM column might be storing the full names of states in a table containing a list of all zip codes in the United States. The zip code would be stored as CHAR(5). The city would be defined as a VARCHAR of however long the longest city name we can find is. The state abbreviation would be CHAR(2), and the full state name could be stored on the table as an ENUM field. (It could also be stored separately as a lookup table, but it may be more performant to store it on the same table.)

SET

A SET field acts like an ENUM field that can contain multiple values. These values, when stored and retrieved, are separated by commas, so the values themselves should not contain commas. They cannot contain more than 64 values in the field definition.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.